﻿using System;
namespace BZZ.Model
{
	/// <summary>
	/// 管理员日志实体类：adminlog 。
	/// </summary>
	[Serializable]
	public class adminlog
	{
		public adminlog()
		{}

		#region Model
		private int _id; //id
		private string _logtype; //日志类型
		private int _adminid; //管理员id
		private DateTime? _operateTime; //操作时间
		private string _operateIP; //操作ip
		private string _operateResult; //操作结果
		private string _ext; //扩展


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 日志类型
		/// </summary>
		public string logtype
		{
			set{ _logtype=value;}
			get{return _logtype;}
		}
        /// <summary>
		/// 管理员id
		/// </summary>
		public int adminid
		{
			set{ _adminid=value;}
			get{return _adminid;}
		}
        /// <summary>
		/// 操作时间
		/// </summary>
		public DateTime? operateTime
		{
			set{ _operateTime=value;}
			get{return _operateTime;}
		}
        /// <summary>
		/// 操作ip
		/// </summary>
		public string operateIP
		{
			set{ _operateIP=value;}
			get{return _operateIP;}
		}
        /// <summary>
		/// 操作结果
		/// </summary>
		public string operateResult
		{
			set{ _operateResult=value;}
			get{return _operateResult;}
		}
        /// <summary>
		/// 扩展
		/// </summary>
		public string ext
		{
			set{ _ext=value;}
			get{return _ext;}
		}
		#endregion Model

		#region txt document
		/*
管理员日志,adminlog
id,日志类型,管理员id,操作时间,操作ip,操作结果,扩展
id,logtype,adminid,operateTime,operateIP,operateResult,ext
i,c20,i,d,c20,c100,c200

--------------------------
-- 创建表[管理员日志]开始: 
-- alter table  [BZZ_adminlog] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='BZZ_adminlog') drop table BZZ_adminlog
  CREATE TABLE [BZZ_adminlog] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [logtype] [varchar] (20),
	 [adminid] int,
	 [operateTime] [datetime],
	 [operateIP] [varchar] (20),
	 [operateResult] [varchar] (100),
	 [ext] [varchar] (200)
  )

 exec sp_addextendedproperty N'MS_Description',N'管理员日志 ',N'user',N'dbo',N'table',N'BZZ_adminlog', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'BZZ_adminlog',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'日志类型',N'user',N'dbo',N'table',N'BZZ_adminlog',N'column',N'logtype'
 exec sp_addextendedproperty N'MS_Description',N'管理员id',N'user',N'dbo',N'table',N'BZZ_adminlog',N'column',N'adminid'
 exec sp_addextendedproperty N'MS_Description',N'操作时间',N'user',N'dbo',N'table',N'BZZ_adminlog',N'column',N'operateTime'
 exec sp_addextendedproperty N'MS_Description',N'操作ip',N'user',N'dbo',N'table',N'BZZ_adminlog',N'column',N'operateIP'
 exec sp_addextendedproperty N'MS_Description',N'操作结果',N'user',N'dbo',N'table',N'BZZ_adminlog',N'column',N'operateResult'
 exec sp_addextendedproperty N'MS_Description',N'扩展',N'user',N'dbo',N'table',N'BZZ_adminlog',N'column',N'ext'

-- 创建表[管理员日志]结束。 
--------------------------

		*/
		#endregion document
	}
}

